package com.isoft.filelistener.dao;

import com.isoft.filelistener.entity.Flight;
import com.isoft.filelistener.entity.MetaData;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface BaseApueDao {
    @Insert("insert into TEAM_03.BASE_APUE(SENDER,RECEIVER,SEQUENCE,SEND_TIME,TYPE,STYP," +
            "FLIGHT_CODE,FLIGHT_FRCD,FLIGHT_APAT,FLIGHT_CNNM,FLIGHT_ENNM,FLIGHT_AISO,FLIGHT_APSN) values(" +
            "#{metaData.sender},#{metaData.receiver},#{metaData.sequence},#{metaData.sendTime},#{metaData.type},#{metaData.styp},#{flight.flightCode},#{flight.flightFrcd}" +
            ",#{flight.flightApat},#{flight.flightCnnm},#{filght.flightEnnm},#{flight.FlightAiso},#{flight.FlightApsn})")
    int InsertBaseApue(@Param("metaData") MetaData metaData,@Param("flight") Flight flight);
}
